home *** CD-ROM | disk | FTP | other *** search
/ The Macintosh Demo Applications CD / Apple-MacintoshDemoApplicationsCD-1.0-1992.bin / More Information / GQL V3.0 / Open ME! - USA Sales / Open ME! - USA Sales.rsrc / QRY_23053_Sales by City < prev    next >
Text File  |  1992-01-27  |  313b  |  1 lines
  1. 100800customer100500order100600placed1400000501140010030215160010020006placed05order160000020008customer06placed18000005011900000500200000172select customer.cust_city, AVG (orders.ord_amount) from customer, orders  where customer.cust_num = orders.cust_nr group by customer.cust_city order by customer.cust_city ;